Personal Computer World 2005 October/PCWOCT05.iso/Software/FromTheMag/XAMPP 1.4.14/xampp-win32-1.4.14-installer.exe/xampp/php/pear/adodb/session/adodb-sessions.oracle.clob.sql

Text File | 2003-11-04 | 281 b | 16 lines

-- $CVSHeader$

DROP TABLE adodb_sessions;

CREATE TABLE sessions (
    sesskey        CHAR(32)    DEFAULT '' NOT NULL,
    expiry        INT        DEFAULT 0 NOT NULL,
    expireref    VARCHAR(64)    DEFAULT '',
    data        CLOB        DEFAULT '',
    PRIMARY KEY    (sesskey)
);

CREATE INDEX ix_expiry ON sessions (expiry);

QUIT;